<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="ko" xml:lang="ko">

<head>
	<title></title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
	<%@page import = "java.util.*,java.text.*"%>
	<link rel="stylesheet" type="text/css" href="../css/base.css" media="all" /> 
	<script type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function CariPemenang() {
	
	var nomorHp = document.getElementById("search").value;

	if(nomorHp=="")
	{
		alert("Isi dengan nomor anda");
		document.getElementById("search").focus();
		return false ;
	}
	if(isNaN(nomorHp))
	{
		alert("Isi dengan nilai angka");
		document.getElementById("search").focus();
		return false;
	}
	if (nomorHp.length<10||nomorHp.length>13)
    {
         alert("Pengisian nomor harus antara 10-13 karakter");
 		document.getElementById("search").focus();
         return false;
    }

	var isTNumber=nomorHp.substring(0,2);

    if(isTNumber != '08')
    {
        alert("Pengisian dimulai dengan nomor 08");
		document.getElementById("search").focus();
        return false;            
    }

    nomorHp = nomorHp.replace('08','628');
    
    var url = String(window.location);
    
    if(url.indexOf("admin=administrator3k") != -1)
    {
    	location.href = './last%20month.html?admin=administrator3k&nomorhp=' + nomorHp;
    }else{
    	location.href = './last%20month.html?nomorhp=' + nomorHp;
    }
}

//-->
</script>

<script type="text/javascript">
function JsMenuView(id) {

	var imgName;
	var re;

	for(i=1 ; i<=4 ; i++) {
		imgName = "../images/common/top_menu0"+i+"_off.gif";
		re = "menu_"+i+"_img";
		document.getElementById(re).src = imgName;
		document.getElementById("submenu_"+i).style.display="none";
	}

	imgName = "../images/common/top_menu0"+id+"_on.gif";
	document.getElementById("menu_"+id+"_img").src = imgName;
	if(document.getElementById("submenu_"+id)){
		document.getElementById("submenu_"+id).style.display="block";
	}
}
function disableEnterKey(e)
{
     var key;

     if(window.event)
          key = window.event.keyCode;     //IE
     else
          key = e.which;     //firefox

     if(key == 13)
          return false;
     else
          return true;
}
</script>
</head>

<body id="wrap_bg">
<div id="accessibility">
	<h1 class="hidden"><a href="/">logo</a></h1>
	<h2 class="hidden"></h2>
	<ul>
		<li><a href="#hearder">main_menu</a></li>
		<li><a href="#left_part">sub_menu</a></li>
		<li><a href="#body_part">contacts</a></li>
		<li><a href="#foot">copyright</a></li>
	</ul>
</div>
<div id="wrap">
	<h2 class="hidden">main_menu</h2>
	<div id="hearder">
<%if(request.getParameter("admin") == null){%>
		<h1><div id="logo"><a href="../index.html"><img src="../images/common/logo.gif" alt="logo" /></a></div></h1>
<%}else if(request.getParameter("admin").equals("administrator3k")){%>		
		<h1><div id="logo"><a href="../main?admin=administrator3k"><img src="../images/common/logo.gif" alt="logo" /></a></div></h1>
<%}%>
		<div id="top_menu">
			<div id="navi-global">
				<%if(request.getParameter("admin") == null){%>
				<ul>
					<li id="menu_1">
						<a href="../biz-ring/whatis.html"  onmouseover="JsMenuView('1');" onfocus="JsMenuView('1'),this.blur();"><img src="../images/common/top_menu01_off.gif" alt="Biz-Ring" border="0" id="menu_1_img" /></a>
						<ul id="submenu_1">
							<li class="text_fff"><a href="../biz-ring/whatis.html" class="top_menu" onfocus="this.blur()">What is Biz-Ring</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/biz-ring.html" class="top_menu" onfocus="this.blur()">Biz-Ring Now</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/Advertising Schedule_list.html" class="top_menu" onfocus="this.blur()">Advertising Schedule</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/notice_list.html" class="top_menu" onfocus="this.blur()">Notice</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>

							<li class="text_fff"><a href="../biz-ring/price.html" class="top_menu" onfocus="this.blur()">Price Notice</a></li>
						</ul>
					</li>
					<li id="menu_2">
						<a href="prize now.html"  onMouseOver="JsMenuView('2')" onFocus="JsMenuView('2'),this.blur();"><img src="../images/common/top_menu02_off.gif" alt="Prize" border="0" id="menu_2_img" /></a>
						<ul id="submenu_2">
							<li class="text_fff"><a href="prize now.html" class="top_menu" onfocus="this.blur()">Prize Now</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="last month.html" class="top_menu" onfocus="this.blur()">Last Month Winner</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="prize notice.html" class="top_menu" onfocus="this.blur()">Prize Notice</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="Prize Request_list.html" class="top_menu" onfocus="this.blur()">Prize Suggestion</a></li>
						</ul>
					</li>
					<li id="menu_3">
						<a href="../customer/information.html" onMouseOver="JsMenuView('3')" onfocus="JsMenuView('3'),this.blur();"><img src="../images/common/top_menu03_off.gif" alt="Customer Center"  border="0" id="menu_3_img" /></a>
						<ul id="submenu_3">
							<li class="text_fff"><a href="../customer/information.html" class="top_menu" onfocus="this.blur()">Information</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../customer/question.html" class="top_menu" onfocus="this.blur()"> Question & Request</a></li>
						</ul>
					</li>
					<li id="menu_4">
						<a href="../business/business.html"onMouseOver="JsMenuView('4')" onfocus="JsMenuView('4'),this.blur();"><img src="../images/common/top_menu04_off.gif" alt="Business Contact" border="0" id="menu_4_img" /></a>
						<ul id="submenu_4">
							<li></li>
						</ul>
					</li>
				</ul>
<%}
else if(request.getParameter("admin").equals("administrator3k")){%>	
				<ul>				
					<li id="menu_1">
						<a href="../biz-ring/whatis.html?admin=administrator3k"  onmouseover="JsMenuView('1');" onfocus="JsMenuView('1'),this.blur();"><img src="../images/common/top_menu01_off.gif" alt="Biz-Ring" border="0" id="menu_1_img" /></a>
						<ul id="submenu_1">
							<li class="text_fff"><a href="../biz-ring/whatis.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">What is Biz-Ring</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/biz-ring.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Biz-Ring Now</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/Advertising Schedule_list.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Advertising Schedule</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/notice_list.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Notice</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../biz-ring/price.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Price Notice</a></li>
						</ul>
					</li>
					<li id="menu_2">
						<a href="prize now.html?admin=administrator3k"  onMouseOver="JsMenuView('2')" onFocus="JsMenuView('2'),this.blur();"><img src="../images/common/top_menu02_off.gif" alt="Prize" border="0" id="menu_2_img" /></a>
						<ul id="submenu_2">
							<li class="text_fff"><a href="prize now.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Prize Now</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="last month.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Last Month Winner</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="prize notice.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Prize Notice</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="Prize Request_list.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Prize Suggestion</a></li>
						</ul>
					</li>
					<li id="menu_3">
						<a href="../customer/information.html?admin=administrator3k" onMouseOver="JsMenuView('3')" onfocus="JsMenuView('3'),this.blur();"><img src="../images/common/top_menu03_off.gif" alt="Customer Center"  border="0" id="menu_3_img" /></a>
						<ul id="submenu_3">
							<li class="text_fff"><a href="../customer/information.html?admin=administrator3k" class="top_menu" onfocus="this.blur()">Information</a>&nbsp;&nbsp;|&nbsp;&nbsp;</li>
							<li class="text_fff"><a href="../customer/question.html?admin=administrator3k" class="top_menu" onfocus="this.blur()"> Question & Request</a></li>
						</ul>
					</li>
					<li id="menu_4">
						<a href="../business/business.html?admin=administrator3k" onMouseOver="JsMenuView('4')" onfocus="JsMenuView('4'),this.blur();"><img src="../images/common/top_menu04_off.gif" alt="Business Contact" border="0" id="menu_4_img" /></a>
						<ul id="submenu_4">
						</ul>
					</li>
				</ul>
<%}%>
			</div><!-- /navi-global -->
		</div>
	</div>

	<div id="container">
		<!-- left-->		
	    <h2 class="hidden">sub_menu</h2>
		<div id="left_part">
			<div id="left_menu">
<%if(request.getParameter("admin") == null){%>
				<ul>
					<p><img src="../images/prize/left_title.gif" alt="Prize" /></p>
					<li><a href="prize now.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image23','','../images/prize/left_menu01_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image23','','../images/prize/left_menu01_on.gif',1),this.blur()"><img src="../images/prize/left_menu01_off.gif" name="Image23" width="161" border="0" id="Image23" alt="Prize Now" /></a></li>
					<li><a href="last month.html"  onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image22','','../images/prize/left_menu02_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image22','','../images/prize/left_menu02_on.gif',1),this.blur()"><img src="../images/prize/left_menu02_off.gif" name="Image22" width="161" border="0" id="Image22" alt="Last Month Winner" /></a></li>
					<li><a href="prize notice.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image24','','../images/prize/left_menu03_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image24','','../images/prize/left_menu03_on.gif',1),this.blur()"><img src="../images/prize/left_menu03_off.gif" name="Image24" width="161" border="0" id="Image24" alt="Prize Notice" /></a></li>
					<li><a href="Prize Request_list.html" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image25','','../images/prize/left_menu04_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image25','','../images/prize/left_menu04_on.gif',1),this.blur()"><img src="../images/prize/left_menu04_off.gif" name="Image25" width="161" border="0" id="Image25" alt="Prize Request" /></a></li>
				</ul>
<%}
else if(request.getParameter("admin").equals("administrator3k")){%>
				<ul>
					<p><img src="../images/prize/left_title.gif" alt="Prize" /></p>
					<li><a href="prize now.html?admin=administrator3k" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image23','','../images/prize/left_menu01_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image23','','../images/prize/left_menu01_on.gif',1),this.blur()"><img src="../images/prize/left_menu01_off.gif" name="Image23" width="161" border="0" id="Image23" alt="Prize Now" /></a></li>
					<li><a href="last month.html?admin=administrator3k"  onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image22','','../images/prize/left_menu02_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image22','','../images/prize/left_menu02_on.gif',1),this.blur()"><img src="../images/prize/left_menu02_off.gif" name="Image22" width="161" border="0" id="Image22" alt="Last Month Winner" /></a></li>
					<li><a href="prize notice.html?admin=administrator3k" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image24','','../images/prize/left_menu03_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image24','','../images/prize/left_menu03_on.gif',1),this.blur()"><img src="../images/prize/left_menu03_off.gif" name="Image24" width="161" border="0" id="Image24" alt="Prize Notice" /></a></li>
					<li><a href="Prize Request_list.html?admin=administrator3k" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image25','','../images/prize/left_menu04_on.gif',1)" onblur="MM_swapImgRestore()" onfocus="MM_swapImage('Image25','','../images/prize/left_menu04_on.gif',1),this.blur()"><img src="../images/prize/left_menu04_off.gif" name="Image25" width="161" border="0" id="Image25" alt="Prize Request" /></a></li>
				</ul>
<%}%>
		    </div>
		</div>

	    <h2 class="hidden">contacts</h2>

		<div id="body_part">
			<div id="body_con">
			
<%
	String connectionUrl = "jdbc:sqlserver://bizring.biz:14333;databaseName=bizring";
	String userid = "sa";
	String passwd = "qlalf@sql";
	String nomorhp = request.getParameter("nomorhp"); 
	
	// Declare the JDBC objects.
	java.sql.Connection con = null;
	
	java.sql.Statement stmt = null;
	java.sql.Statement stmt2 = null;
	java.sql.Statement stmt3 = null;
	
	java.sql.ResultSet rs = null;
	java.sql.ResultSet rs2 = null;
	java.sql.ResultSet rs3 = null;
	
	String year = "";
	String PreviousMonth = "";
	String date = "";
	
	// Establish the connection.
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	
	try{
		String SQL = " select top 1 d.year, d.month, d.date												" +
					 "  from prize_detail d 															" +
					 " where year * 100 + month = (select MAX (year * 100 + month) from prize_detail)	" ;
					 
		con = java.sql.DriverManager.getConnection(connectionUrl, userid, passwd);
		stmt = con.createStatement();
		rs = stmt.executeQuery(SQL);
		
		rs.next();
		
		year = rs.getString("year");
		date = rs.getString("date");
		
		if(rs.getString("month").equals("1") ){
			PreviousMonth = "January";
		}else if(rs.getString("month").equals("2") ){
			PreviousMonth = "Februari";
		}else if(rs.getString("month").equals("3") ){
			PreviousMonth = "Maret";
		}else if(rs.getString("month").equals("4") ){
			PreviousMonth = "April";
		}else if(rs.getString("month").equals("5") ){
			PreviousMonth = "Mei";
		}else if(rs.getString("month").equals("6") ){
			PreviousMonth = "Juni";
		}else if(rs.getString("month").equals("7") ){
			PreviousMonth = "Juli";
		}else if(rs.getString("month").equals("8") ){
			PreviousMonth = "Agustus";
		}else if(rs.getString("month").equals("9") ){
			PreviousMonth = "September";
		}else if(rs.getString("month").equals("10") ){
			PreviousMonth = "Oktober";
		}else if(rs.getString("month").equals("11") ){
			PreviousMonth = "November";
		}else if(rs.getString("month").equals("12") ){
			PreviousMonth = "Desember";
		}
		
		out.println("<p  class=\"text_tit\" style=\"padding:40px 0 27px 16px;\">Penarikan undian pertama tanggal " 
						+ date + " " + PreviousMonth + " " + year + "<br/></p>");
	} catch (java.sql.SQLException e) {
        e.printStackTrace();   
    } catch (Exception e) {
    	e.printStackTrace();
    } finally{   
        try {   
            if(stmt !=null) stmt.close();   
            if(con !=null) con.close();   
        } catch (java.sql.SQLException e) {
            e.printStackTrace();   
        }   
    }

%>			
				<div class="ta_top"></div>
				<div class="ta_bg">

				<!-- Cari Pemenang -->
				<br/>
				<div style="float:left;width:223px;height:33px;margin-left:20px;background-image:url(../images/customer/search_bg.gif);">
					<input type="text" name="search" id="search" value="Nomor Anda" onkeypress="return disableEnterKey(event)" onfocus="this.value='';" size="30" class="form_search" maxlength="" title="" />
					<p class="search_ex">ex)081123457890</p>
				</div>
				<div class="search_btn"><a href="#" onclick="CariPemenang()"><img src="../images/common/btn_cari.gif" alt="send" align="absmiddle"></a></div>
				<br/><br/><br/>

					<div class="bs_con">
						<p class="text_orange">
						<br/><br/>

<%
	try {   
		// Create and execute an SQL statement that returns some data.

		//nomorhp = "6281260195908";
						
		String SQL = "select w.msisdn, d.prize_name, d.year, d.date										" +
					 "  from prize_winner w, prize_detail d 											" + 
					 " where w.prize_id = d.id															" + 
					 " 	 and year * 100 + month = (select MAX (year * 100 + month) from prize_detail)	" +
					 "   and w.msisdn = '" + nomorhp + "' 												" ;
		String msg = "";

		con = java.sql.DriverManager.getConnection(connectionUrl, userid, passwd);
		stmt = con.createStatement();
		rs = stmt.executeQuery(SQL);

		rs.next();

		// Iterate through the data in the result set and display it.
		if (nomorhp != null && nomorhp != ""){
			if (rs.getRow()!= 0) {
				msg = 	"Selamat!<br/> Nomor anda (<b>"+nomorhp.replace("628","08")+"</b>) termasuk dalam daftar pemenang<br/><b>" + rs.getString("prize_name") + 
						"</b><br/> pada undian pada tanggal " + date + " " + PreviousMonth + " " + year + ".<br><br>Untuk verifikasi lebih lanjut, " +
						"anda dapat menghubungi kami melalui nomor Customer Service<br/>0821-1234-2300<br/><br/> " +
						"selambat-lambatnya 25 Juli 2011 <br/><br/>";
			}
			else{
				msg	=	"Nomor anda (<b>"+nomorhp.replace("628","08")+"</b>) belum terpilih sebagai pemenang undian pada tanggal " 
							+ date + " " + PreviousMonth + " " + year + ",<br/>" +
								" tapi anda tetap berpeluang untuk ikut undian di periode berikutnya secara otomatis.<br/><br/>";
			}
			out.println(msg);
		}
		
	} catch (java.sql.SQLException e) {
        e.printStackTrace();   
    } catch (Exception e) {
    	e.printStackTrace();
    } finally{   
        try {   
            if(stmt !=null) stmt.close();   
            if(con !=null) con.close();   
        } catch (java.sql.SQLException e) {   
            e.printStackTrace();   
        }   
    }   

%>
<br/>
<table style='width:357pt;margin-left:4.2pt;'>
 <tr style='height:16.5pt'>
  <td style='width:223.0pt;border:solid windowtext 1.0pt;background:#FDE9D9;padding:0 5pt 0 5pt'>
  <span style='font-size:11.0pt;color:black'>Hadiah</span>
  </td>
  <td style='width:25pt;border:solid windowtext 1.0pt;background:#FDE9D9;padding:0 5pt 0 5pt'>
  <p style = 'text-align:center;'><span style='font-size:11.0pt;color:black;'>#</span></p>
  </td>
  <td style='width:223.0pt;border:solid windowtext 1.0pt;background:#FDE9D9;padding:0 5pt 0 5pt'>
  <span style='font-size:11.0pt;color:black'>Nomor H.P</span>
  </td>
 </tr>
<%	
	String id = "";

	try {
		String prizeWinnerList =	"select d.id, d.prize_name, w.seq , w.msisdn										" +
									"  from prize_winner as w inner join prize_detail as d on w.prize_id = d.id			" +
									" where year * 100 + month = (select MAX (year * 100 + month) from prize_detail)	" +
									" order by d.id desc, w.seq															" ;
		
		String eachPrizeCount  =    "select d.id, d.prize_name, COUNT (*) as rowspan									" +
			  						"  from prize_winner as w inner join prize_detail as d on w.prize_id = d.id			" +
			  						" where year * 100 + month = (select MAX (year * 100 + month) from prize_detail)	" +
			  						" group by d.id, d.prize_name														" +
			  						" order by d.id desc																" ;
		
		String totalPrizeCount =    "select COUNT (*) as totalprizecnt													" +
		  							"  from prize_detail as d															" +
		  							" where year * 100 + month = (select MAX (year * 100 + month) from prize_detail)	" ;
//year*100+month
		con = java.sql.DriverManager.getConnection(connectionUrl, userid, passwd);
		
		stmt = con.createStatement();
		stmt2 = con.createStatement();
		stmt3 = con.createStatement();
	
		rs = stmt.executeQuery(prizeWinnerList);
		rs2 = stmt2.executeQuery(eachPrizeCount);
		rs3 = stmt3.executeQuery(totalPrizeCount);
		
		int totalPrize = 0; 
		int i = 0;
		int k = 0;
		
		while(rs3.next()){
			totalPrize = Integer.parseInt(rs3.getString("totalprizecnt"));
		}	
		String arrPrizeCount[][] = new String[totalPrize][2];
		
		while(rs2.next()){
			arrPrizeCount[i][0] = rs2.getString("id");
			arrPrizeCount[i][1] = rs2.getString("rowspan");
			i++;
		}
%>
<tr style='height:16.5pt'>
<%
		while (rs.next()) {
%>

<%if(rs.getString("id").equals(arrPrizeCount[k][0]) && !arrPrizeCount[k][1].equals("1") && rs.getString("seq").equals("1")){%>
  <td rowspan=<%=arrPrizeCount[k][1]%> style='width:2300.0pt;border:solid windowtext 1.0pt;padding:0 5pt 0 5pt;'>
  	<span style='font-size:11.0pt;color:black'><%=rs.getString("prize_name")%></span>
  </td>
<%}else if(rs.getString("id").equals(arrPrizeCount[k][0]) && arrPrizeCount[k][1].equals("1") && rs.getString("seq").equals("1")){%>
  <td style='width:2300.0pt;border:solid windowtext 1.0pt;padding:0 5pt 0 5pt;'>
  	<span style='font-size:11.0pt;color:black'><%=rs.getString("prize_name")%></span>
  </td>
<%}%>
  <td style='width:25pt;border:solid windowtext 1.0pt;padding:0 5pt 0 5pt'>
  	<p style = 'text-align:center;'><span style='font-size:11.0pt;color:black;'><%=rs.getString("seq")%></span></p>
  </td>
  <td style='width:150.0pt;border:solid windowtext 1.0pt;padding:0 5pt 0 5pt'>
<%if(request.getParameter("nomorhp") != null && request.getParameter("nomorhp").equals(rs.getString("msisdn"))){%>
  	<span style='font-size:11.0pt;color:red'>0<%=rs.getString("msisdn").substring(2, rs.getString("msisdn").length() -3)%>***</span>
<%}else{%>
	<span style='font-size:11.0pt;color:black'>0<%=rs.getString("msisdn").substring(2, rs.getString("msisdn").length() -3)%>***</span>
<%}%>  
  </td>
 </tr>
<%if(rs.getString("seq").equals(arrPrizeCount[k][1])){
	k++;
}
		}
	} catch (java.sql.SQLException e) {
		e.printStackTrace();
	} finally {
		try {   
            if(stmt !=null) stmt.close();   
            if(con !=null) con.close();   
        } catch (java.sql.SQLException e) {   
            e.printStackTrace();
        }
	}
%>
</table>
<br/><br/>
<object width="480" height="390">
<param name="movie" value="http://www.youtube.com/v/ya5fZtvwZ1E?version=3&amp;hl=ko_KR"></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param>
<embed src="http://www.youtube.com/v/ya5fZtvwZ1E?version=3&amp;hl=ko_KR" type="application/x-shockwave-flash" 
width="480" height="390" allowscriptaccess="always" allowfullscreen="true"></embed>
</object>
			<br/><br/><br/>
			<b>Ketentuan Pengambilan Hadiah</b><br/>
			________________________________________<br/>
			1.	Pemenang memberikan konfirmasi nomor telepon seluler dengan menyertakan data<br/> 
			&nbsp;&nbsp;&nbsp;&nbsp; diri: Nama, Email, Alamat, No.KTP<br/>
			2.	Wajib membawa kartu SIM pada saat pengambilan hadiah, <br/>
			&nbsp;&nbsp;&nbsp;&nbsp;jika tidak bisa menunjukan kartu SIM yang asli dianggap gugur.<br/>
			3.	Periode pengambilan hadiah selama 20 hari kerja & pada jam kerja, <br/>
			&nbsp;&nbsp;&nbsp;&nbsp;terhitung dari tanggal 7 Juli sampai 25 Juli 2011 di PT. Kami Kaya Kreasi (3K). <br/>
			&nbsp;&nbsp;&nbsp;&nbsp;Pengambilan hadiah diluar periode tersebut, <br/>
			&nbsp;&nbsp;&nbsp;&nbsp;dianggap hangus dan hadiah akan diserahkan kepada KEMENSOS RI.<br/>
			4.	Hadiah tidak bisa diuangkan oleh pemenang dan tidak bisa diwakilkan.<br/>
			5.	Pajak Hadiah ditanggung oleh pemenang.<br/>
			6.	Keputusan Panitia bersifat mutlak dan tidak bisa diganggu gugat.<br/>


							<br/><br/>
						</p>
					</div>					
				</div>
				<div class="ta_bot"></div>
			</div>		
		</div>
	</div>

	<h2 class="hidden">copyright</h2>
	<div id="foot">
		<div id="foot_part">
			<p id="line_solid"></p>
			<div class="foot_adress">
				<ul>
					<li class="logo"><img src="../images/common/tsellogo.png" alt="Powered by TELKOMSEL" /></li>
					<li class="address">
						<div class="f_address">
							<address>
							<img src="../images/common/copyright.gif" alt="This site is The Telkomsel Small Ring Service website.   /   BizRing Operator : PT. Kami Kaya Kreasi
Address : Jl. Daksa IV, No. 69, Kebayoran Baru, Jakarta Selatan - 12110 Indonesia
Tel +62 21 723 5038  Fax +62 21 723 5037  info@kamikayakreasi.com
wwww.kamikayakreasi.com" />
							</address>					
						</div>
					</li>
				</ul>
			</div>	
		</div>
	</div>
 
</div>
</BODY>
</HTML>
